From 3006f8ad16c6eb9aa75303286e8a2716a2a8f251 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Sat, 11 Jul 2026 22:28:24 +0000 Subject: [PATCH] Fix to ensure arrival at the feeding station is the WATCHES.AnimID --- db/schemas/lib/triggers/create/roles.m4 | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/db/schemas/lib/triggers/create/roles.m4 b/db/schemas/lib/triggers/create/roles.m4 index 7989651..94399b0 100644 --- a/db/schemas/lib/triggers/create/roles.m4 +++ b/db/schemas/lib/triggers/create/roles.m4 @@ -431,11 +431,13 @@ CREATE OR REPLACE FUNCTION roles_func () END IF; -- - -- The participant must be the focal for food events, for gps location - -- events, and for map location events + -- The participant must be the focal for food events, for arrivals + -- at the feeding station, for gps location events, and for map + -- location events. -- IF TG_OP = 'INSERT' AND (a_behavior = 'sdb_food' + OR a_behavior = 'sdb_arrival_a' OR a_behavior = 'sdb_utm' OR a_behavior = 'sdb_paper') THEN DECLARE -- 2.34.1